create external table jms_dm.dm_ass_scan_effective_cnt_dt 
(
  scan_date date COMMENT '日期', 
  network_code string COMMENT '网点code', 
  network_name string COMMENT '网点名称', 
  scan_cnt bigint COMMENT '操作量', 
  operate_type string COMMENT '模式 1.出港 2.进港', 
  usage_duration string COMMENT '使用时长', 
  effective decimal(16,4) COMMENT '效能', 
  date_time date COMMENT '查询日期'
)
comment '供件台效能'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_ass_scan_effective_cnt_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
